CREATE PROC [dbo].[BAEAccountPendingInsert]
    @Username varchar(64),
    @Password varchar(104),
    @Prefix varchar(32),
    @FirstName varchar(24),
    @MiddleInitial varchar(24),
    @LastName varchar(302),
    @Suffix varchar(16),
    @Designation varchar(32),
    @Informal varchar(32),
    @Title varchar(96),
     @Organization varchar(96),
    @Address1 varchar(48),
    @Address2 varchar(48),
    @Address3 varchar(48),
    @County varchar(56),
    @City varchar(48),
    @StateProvince varchar(16),
    @PostalCode varchar(16),
    @Country varchar(24),
    @AddressPurpose varchar(24),
    @Email varchar(128),
    @Website varchar(128),
    @WorkPhone varchar(24),
    @HomePhone varchar(24),
    @TollFree varchar(24),
    @Fax varchar(24),
    @BirthDate varchar(24),
    @Gender varchar(8),
    @SICCode varchar(32),
    @ExcludeDirectory bit,
    @UserDefinedField text,
    @ExcludeMail bit,
    @RecordAdded bit,
    @MemberType varchar(5)
AS
    INSERT INTO AccountPending (Username, [Password], Prefix, FirstName, MiddleName, LastName, Suffix, Designation, Informal, Title, Organization, Address1, Address2, Address3,
                    County, City, StateProvince, PostalCode, Country, AddressPurpose, Email, Website, WorkPhone, HomePhone,
                    TollFree, Fax, BirthDate, Gender, SICCode, ExcludeDirectory,UserDefinedField, ExcludeMail,RecordAdded, MemberType)
    VALUES (@Username, @Password, @Prefix, @FirstName, @MiddleInitial, @LastName,  @Suffix, @Designation, @Informal, @Title, @Organization, @Address1, @Address2, @Address3,
            @County, @City, @StateProvince, @PostalCode, @Country, @AddressPurpose,@Email, @Website, @WorkPhone, @HomePhone,
            @TollFree,@Fax, @BirthDate, @Gender, @SICCode, @ExcludeDirectory, @UserDefinedField, @ExcludeMail,@RecordAdded, @MemberType);

    SELECT CAST(@@IDENTITY AS int) 'InsertedAccountPending';


----------------------------
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON

GO